Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Ответить на вопрос можно ниже ⬇️
BY SQL для тестировщика
Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283
In general, many financial experts support their clients’ desire to buy cryptocurrency, but they don’t recommend it unless clients express interest. “The biggest concern for us is if someone wants to invest in crypto and the investment they choose doesn’t do well, and then all of a sudden they can’t send their kids to college,” says Ian Harvey, a certified financial planner (CFP) in New York City. “Then it wasn’t worth the risk.” The speculative nature of cryptocurrency leads some planners to recommend it for clients’ “side” investments. “Some call it a Vegas account,” says Scott Hammel, a CFP in Dallas. “Let’s keep this away from our real long-term perspective, make sure it doesn’t become too large a portion of your portfolio.” In a very real sense, Bitcoin is like a single stock, and advisors wouldn’t recommend putting a sizable part of your portfolio into any one company. At most, planners suggest putting no more than 1% to 10% into Bitcoin if you’re passionate about it. “If it was one stock, you would never allocate any significant portion of your portfolio to it,” Hammel says.
The S&P 500 slumped 1.8% on Monday and Tuesday, thanks to China Evergrande, the Chinese property company that looks like it is ready to default on its more-than $300 billion in debt. Cries of the next Lehman Brothers—or maybe the next Silverado?—echoed through the canyons of Wall Street as investors prepared for the worst.
